package wj.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JdbcUtils {
        public static int update(String sql) throws Exception{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/test?useSSL=false";
            String username = "root";
            String password = "root";
            Connection connection = DriverManager.getConnection(url, username, password);
            Statement statement = connection.createStatement();
            int i = statement.executeUpdate(sql);
            return i;
        }

        public static void select(String sql) throws Exception{
            Class.forName("com.mysql.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/test?useSSL=false";
            String username = "root";
            String password = "root";
            Connection connection = DriverManager.getConnection(url, username, password);
            Statement statement = connection.createStatement();
            ResultSet set = statement.executeQuery(sql);
            System.out.println("查找到的内容为：");
            while(set.next()){
                String a = set.getString(1);
                String b = set.getString(2);
                System.out.println(a+" "+b);
            }
        }
    }




